/*
 *  Copyright 2015-2016, RenGu Technology (BeiJing) Co., Ltd.
 *  All right reserved.
 *
 *  THIS IS UNPUBLISHED PROPRIETARY SOURCE CODE OF RENGU TECHNOLOGY (BeiJing) CO., LTD.
 *
 *  THE CONTENTS OF THIS FILE MAY NOT BE DISCLOSED TO THIR PARTIES,
 *  COPIED OR DUPLICATED IN ANY FORM, IN WHOLE OR IN PART,
 *  WITHOUT THE PRIOR WRITTEN PERMISSION OF RENGU TECHNOLOGY (BeiJing) CO., LTD.
 *
 *  AcctSqlId
 *
 *  Edit History:
 *      lizhangtao Created on 2020年04月09日
 *
 */
package cc.rengu.igas.acct.common.constant;

/**
 * 数据库操作id常量
 *
 * @author lizhangtao
 * @version 1.0
 * @date 2020/5/8
 */
public class AcctSqlMapperId {

    /**
     * 插入账户信息表
     */
    public final static String INSERT2ACCT_INFO = "ACCTInsert2AcctInfo";

    /**
     * 获取账户序列号
     */
    public final static String GET_ACCT_NO_SEQ = "ACCTGetNextAcctNoSequenceNo";

    /**
     * 获取交易流水号序列号
     */
    public final static String GET_ACCT_SEQ_NUM_SEQ = "ACCTGetNextAcctSeqNumSequenceNo";

    /**
     * 查询账户客户信息表以外部用户类型和用户ID
     */
    public final static String SELECT_CUSTOMER_BY_USER_ID = "ACCTSelectAcctCustomInfoByUserId";

    /**
     * 查询账户客户信息表以客户ID
     */
    public final static String SELECT_CUSTOMER_BY_CUSTOMER_ID = "ACCTSelectAcctCustomInfoByCustomerId";

    /**
     * 插入账户客户信息表
     */
    public final static String INSERT2CUSTOMER_INFO = "ACCTInsert2AcctCustomerInfo";

    /**
     * 以机构号和客户号查询账户信息表
     */
    public final static String SELECT_ACCT_INFO_BY_CUSTOMER_ID = "ACCTSelectAcctInfoByCustomerId";

    /**
     * 以机构号和账号查询账户信息表
     */
    public final static String SELECT_ACCT_INFO_BY_ACCT_NO = "ACCTSelectAcctInfoByAcctNo";

    /**
     * 以机构号和外部用户类型及用户标识查询账户信息表
     */
    public final static String SELECT_ACCT_INFO_BY_USER_ID = "ACCTSelectAcctInfoByUserId";

    /**
     * 以机构号和客户号更新账户信息状态
     */
    public final static String UPD_ACCT_INFO_BY_CUSTOMER_ID = "ACCTUpdAcctInfoByCustomerId";

    /**
     * 删除客户信息
     */
    public final static String DEL_CUSTOMER_BY_CUSTOMER_ID = "ACCTDelCustomerByCustomerId";

    /**
     * 更新客户信息状态
     */
    public final static String UPD_CUSTOMER_STATUS_BY_CUSTOMER_ID = "ACCTUpdCustomerStatusByCustomerId";

    /**
     * 以机构号和客户号锁定账户信息表
     */
    public final static String LOCK_ACCT_INFO_BY_CUSTOMER_ID = "ACCTLockAcctInfoByCustomerId";

    /**
     * 以机构号和账号锁定账户信息表
     */
    public final static String LOCK_ACCT_INFO_BY_ACCT_NO = "ACCTLockAcctInfoByAcctNo";

    /**
     * 以机构号和外部用户类型及用户标识锁定账户信息表
     */
    public final static String LOCK_ACCT_INFO_BY_USER_ID = "ACCTLockAcctInfoByUserId";

    /**
     * 以账号冻结账户余额
     */
    public final static String FREEZE_ACCT_INFO_BY_ACCT_NO = "ACCTFreezeAcctInfoByAcctNo";

    /**
     * 以账号解冻并贷记账户余额
     */
    public final static String UNFREEZE_ACCT_INFO_BY_ACCT_NO = "ACCTUnfreezeAcctInfoByAcctNo";

    /**
     * 以账号正常借贷记更新账户余额
     */
    public final static String UPD_ACCT_BAL_BY_ACCT_NO = "ACCTUpdAcctBalByAcctNo";

    /**
     * 查询日切信息
     */
    public final static String SELECT_ACCT_DAY_CUT_BY_INST_ID = "ACCTSelectAcctDayCutByInstId";

    /**
     * 锁定机构日切信息
     */
    public final static String LOCK_ACCT_DAY_CUT_BY_INST_ID = "ACCTLockAcctDayCutByInstId";

    /**
     * 插入记账明细表
     */
    public final static String INSERT2ACCT_DETAIL = "ACCTInsert2AcctDetail";

    /**
     * 更新明细为已经撤销
     */
    public final static String UPD_ACCT_DETAIL_CANCELED = "ACCTUpdAcctDetailCanceled";

    /**
     * 更新明细为已经完成
     */
    public final static String UPD_ACCT_DETAIL_COMPLETED = "ACCTUpdAcctDetailCompleted";

    /**
     * 查询记账明细表
     */
    public final static String SELECT_ACCT_DETAIL_BY_ACCT_SEQ_NUM = "ACCTSelectAcctDetailByAcctSeqNum";

    /**
     * 查询记账明细表
     */
    public final static String SELECT_ACCT_DETAIL_BY_FRONT_SEQ_NUM = "ACCTSelectAcctDetailByFrontSeqNum";

    /**
     * 统计指定账户交易日期段内交易总数
     */
    public final static String COUNT_BY_TXN_DATE_AND_ACCT_NO = "ACCTCountByTxnDateAndAcctNo";

    /**
     * 查询指定账户交易日期段内、指定页数的交易明细
     */
    public final static String FETCH_LIST_BY_TXN_DATE_AND_ACCT_NO_AND_PAGE = "ACCTFetchListByTxnDateAndAcctNoAndPage";

    /**
     * 查询指定客户交易日期段内、指定页数的交易明细
     */
    public final static String FETCH_LIST_BY_TXN_DATE_AND_CUSTOMER_ID_AND_PAGE = "ACCTFetchListByTxnDateAndCustomerIdAndPage";

    /**
     * 查询指定外部用户交易日期段内、指定页数的交易明细
     */
    public final static String FETCH_LIST_BY_TXN_DATE_AND_USER_AND_PAGE = "ACCTFetchListByTxnDateAndUserAndPage";

    /**
     * 查询指定外部原请求流水的交易明细
     */
    public final static String FETCH_LIST_BY_FRONT_SEQ_NUM = "ACCTFetchListByFrontSeqNum";

    /**
     * 查询指定外部原请求流水的交易明细只查一条
     */
    public static final String SELECT_ACCT_DETAIL_BY_FRONT_SEQ_NUM_CUSTOMER_ID_AND_USER_ID = "ACCTSelectAcctDetailByFrontSeqNumCustomerIdAndUserId";

    /*  查询对应预授权完成或预授权撤销交易流水-使用预授权冻结流水作为原交易*/
    public static final String FETCH_LIST_BY_ORIG_ACCT_SEQ_NUM = "ACCTFetchListByOrigAcctSeqNum";
}
